You can insert merge fields into your merge publication in Publisher. The merge fields are placeholders for the text and picture information that will vary in each copy of the finished publication. Your mail merge, e-mail merge, or catalog merge publication must be connected to a data source before you can insert merge fields.

In the Mail Merge Recipients dialog box, click the name of the data source and then click Edit. In the Edit Data Source box you can edit or delete existing addresses, or add new entrys. When you are done editing the address list, click OK and then Yes to update the address list. Note: For more information about creating a data source or an ...

This article will help you get answers to the most common mail merge issues when using Publisher: Making changes to a data source or address list during the mail merge process, adding spaces to a merge field so that it looks the way you want it to, saving the merged publication, and printing different merged pages on a sheet (for example ...

Use mail merge rules such as fil in, if/then, next, previous, or skip record to customize your mail merge.

Go to Data > Consolidate. In the Function box, select the function that you want Excel to use to consolidate the data. In each source sheet, select your data. The file path is entered in All references. When you have added the data from each source sheet and workbook, select OK. Combine by category.

Windows macOS. You've built a list of contacts and other data that you want to use for a Word mail merge. If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge.

Mail merge lets you create a batch of personalized letters where each letter is identical in layout, formatting, text, and graphics, except for personalized parts like the salutation.

In Microsoft Office Word 2007, click Start Mail Merge in the Start Mail Merge group on the Mailings tab, and then click Step by Step by Mail Merge Wizard. Under Select document type, click Letters. The active document becomes the main document. The main document contains the text and graphics that are the same for each version of the merged ...

Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work. If you don't yet have a data source, you can even type it up in Word, as part ...

Click in your document where you want to add the mail merge field. Click the arrow next to Insert Merge Field, and then click the field name. If you don’t see your field name in the list, click the Insert Merge Field button. Click Database Fields to see the list of fields that are in your data source. Click the field you want to add.